<?php
		include("dbconn.inc");
		include("dbfuc.inc");
		include("session.inc");		
		$user=$_SESSION["user"];
		$curid=$_SESSION["curid"];
		$dbconnection=$_SESSION["dbconnection"];		
	if(session_is_registered("dbconnection") )
	{
	
?>
<html>
<head>
<title>inner</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css">
<!--
body {
	margin-left: 0px;
	margin-top: 0px;
	margin-right: 0px;
	margin-bottom: 0px;
}
.style1 {	font-size: 9px;
	font-family: Geneva, Arial, Helvetica, sans-serif;
	font-weight: bold;
}
.style7 {font-family: Geneva, Arial, Helvetica, sans-serif}
-->
</style>
<link href="stylesheet.css" rel="stylesheet" type="text/css">
</head>
<body bgcolor="#FFFFFF">
<!-- ImageReady Slices (inner.psd) -->
<table id="Table_01" width="1003" border="0" cellpadding="0" cellspacing="0">
	<tr>
		<td colspan="10"><object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=7,0,19,0" width="1003" height="167">
          <param name="movie" value="images/inner_header.swf">
          <param name="quality" value="high">
          <embed src="images/inner_header.swf" quality="high" pluginspage="http://www.macromedia.com/go/getflashplayer" type="application/x-shockwave-flash" width="1003" height="167"></embed>
	    </object></td>
	</tr>
	<tr>
		<td rowspan="2">
			<img src="images/inner_02.jpg" width="220" height="29" alt=""></td>
		<td rowspan="2">
			<img src="images/inner_03.jpg" width="98" height="29" alt=""></td>
		<td>
			<img src="images/inner_04.jpg" width="44" height="6" alt=""></td>
		<td rowspan="2">
			<img src="images/inner_05.jpg" width="47" height="29" alt=""></td>
		<td rowspan="2">
			<img src="images/inner_06.jpg" width="54" height="29" alt=""></td>
		<td rowspan="2">
			<img src="images/inner_07.jpg" width="102" height="29" alt=""></td>
		<td rowspan="2">
			<img src="images/inner_08.jpg" width="96" height="29" alt=""></td>
		<td rowspan="2">
			<img src="images/inner_09.jpg" width="124" height="29" alt=""></td>
		<td rowspan="2">
			<img src="images/inner_10.jpg" width="106" height="29" alt=""></td>
		<td rowspan="2">
			<img src="images/inner_11.jpg" width="112" height="29" alt=""></td>
	</tr>
	<tr>
		<td>
			<img src="images/inner_12.jpg" width="44" height="23" alt=""></td>
	</tr>
	<tr>
		<td height="19" background="images/inner_15.jpg">&nbsp;</td>
		<td colspan="9" rowspan="2" valign="top" bgcolor="#FFFFFF"><p>&nbsp;</p>
          <table width="98%" align="center" cellpadding="0" cellspacing="0">
            <tr>
              <td>
<?php
		if(($user!="") && (($curid!="") || ($curid!=0)))
		{
			$sql="";

			$transfer_points=$_SESSION["transfer_points"];
			$tran_user=$_SESSION["tran_user"];
			$id=$_SESSION["id"];
			
			$sql="select N_POINT from POINT_MASTER where N_ID=$curid ";
			$result=mysql_query($sql);
			$rownum=mysql_num_rows($result);
			if($rownum >0)
			{
				$rownum=$rownum-1;
				$transfer_user_point=mysql_result($result,$rownum,"N_POINT");
			
			}

			$sql="select N_POINT from POINT_MASTER where N_ID=$id ";
			$result=mysql_query($sql);
			$rownum=mysql_num_rows($result);
			if($rownum >0)
			{
				$rownum=$rownum-1;
				$recevied_user_point=mysql_result($result,$rownum,"N_POINT");
				$existinpointmaster_flag=true;
			
			}
			$maxvouchur=0;
			$sql="select max(n_vouchur) maxvouchur from transcation_details ";
			$result=mysql_query($sql);
			$rownum=mysql_num_rows($result);
			if($rownum >0)
			{
				$rownum=$rownum-1;
				$maxvouchur=mysql_result($result,$rownum,"maxvouchur");
			
			}			
			$maxvouchur=$maxvouchur+1;
			//new member values are inserting to the master table
			if($existinpointmaster_flag)
			{
				$recevied_user_point=$recevied_user_point+$transfer_points;
				$sqlpoint_master="update point_master set n_id='$id',n_point='$recevied_user_point' where n_id='$id'";				
			}
			else
			{
				$sqlpoint_master="insert into point_master(n_id,n_point) values ('$id','$transfer_points')";
			}
			$transfer_user_point=$transfer_user_point-$transfer_points;
			$sqlpoint_master_update="update point_master set n_id='$curid',n_point='$transfer_user_point' where n_id='$curid'";
			$sqlpoint_transcation_credit="insert into transcation_details(N_FROM_ID,N_TO_ID,C_TRAN_TYPE,N_VOUCHUR,N_AMOUT,N_DEDUCTION,D_DATE) values ('$curid','$id','CREDIT','$maxvouchur','$transfer_points',0,now())";
			$sqlpoint_transcation_debit="insert into transcation_details(N_FROM_ID,N_TO_ID,C_TRAN_TYPE,N_VOUCHUR,N_AMOUT,N_DEDUCTION,D_DATE) values ('$id','$curid','DEBIT','$maxvouchur','$transfer_points',0,now())";
										
			mysql_query($sqlpoint_master);
			mysql_query($sqlpoint_master_update);
			mysql_query($sqlpoint_transcation_credit);
			mysql_query($sqlpoint_transcation_debit);
			
?>		
<br>
<table width="369" border="1" align="center" cellpadding="4" cellspacing="4" bordercolor="#666666">
  <tr>
    <td width="349" colspan="2" bgcolor="#CCCCCC" class="style19"><span class="style20"> Amount Transfer Details:-</span></td>
  </tr>
  <tr>
    <td height="30" class="style23">Amount transcation completed successfully </td>
  </tr>
</table></td>
            </tr>
          </table>          
          <p>&nbsp;</p>
</td>
	</tr>
	<tr>
		<td valign="top" background="images/inner_15.jpg"><table width="95%" align="center" cellpadding="0" cellspacing="0">
          <tr>
            <td><div class="arrowlistmenu">
                <ul>
                  <li><a href="validation_success.php" class="style1 style7">Control Panal  </a></li>
                  <li><a href="registration_step1.php" class="style1">Registration</a></li>
                  <li><a href="geneology.php" class="style1">Geneology </a></li>
                  <li><a href="amount_transfer.php" class="style1">Amount Transfer  </a></li>
                  <li><a href="amount_transfer_details.php" class="style1">Transaction Details  </a></li>
                  <li><a href="pindetails.php" class="style7">Received Coupon Details  </a></li>
				  <li><a href="user_profile.php" class="style7">View Profile   </a></li>
				  <li><a href="change_password.php" class="style7">Password Change </a></li>
				  <li><a href="logout.php" class="style7">Logout  </a></li>
                </ul>
            </div></td>
          </tr>
        </table>	    <p>&nbsp;</p></td>
	</tr>
	<tr>
		<td colspan="10">
			<img src="images/inner_16.jpg" width="1003" height="23" alt=""></td>
	</tr>
</table>
<!-- End ImageReady Slices -->
</body>
</html>

<?php
	}
	}
	else
	{
		$errormsg="Your session is expeired. Please login again.";
		header("location: index.php?error=$errormsg");
	}
?>	
